﻿CREATE PROCEDURE LoadDevelopersByName
	@Nome varchar(30)
AS
SELECT Id as Id, Nome as Name, Cognome as Surname FROM Sviluppatore WHERE Nome Like '%' + @Nome +  '%'
--SELECT 
--	Developer.Id as Id, Developer.Nome as Name, Developer.Cognome as Surname,
--	Skill.Id as Id1, Skill.Descrizione as [Description], Skill.[Rank] as [Rank]
--FROM Sviluppatore  as Developer
--INNER JOIN Competenza as Skill on Developer.Id = Skill.SviluppatoreId
--WHERE Nome Like '%' + @Nome + '%'